Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	2680040
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	347.6 MiB
Average record size in memory	136.0 B

Variable types

Numeric	14
Categorical	3

Alerts

`geo_country` has a high cardinality: 220 distinct values	High cardinality
`event_timestamp` has a high cardinality: 1722186 distinct values	High cardinality
`mission_difficulty` is highly correlated with `mission_stars_collected` and 1 other fields	High correlation
`mission_stars_collected` is highly correlated with `mission_difficulty` and 4 other fields	High correlation
`day_auto_increment` is highly correlated with `days_played_in_month`	High correlation
`lifetime_played_runs` is highly correlated with `mission_stars_collected` and 3 other fields	High correlation
`max_run_distance` is highly correlated with `mission_stars_collected` and 2 other fields	High correlation
`total_purchases_virtual` is highly correlated with `virtual_currency_balance`	High correlation
`total_ads_watched` is highly correlated with `mission_stars_collected` and 2 other fields	High correlation
`days_played_in_month` is highly correlated with `day_auto_increment`	High correlation
`virtual_currency_balance` is highly correlated with `total_purchases_virtual`	High correlation
`mission_played` is highly correlated with `mission_difficulty` and 4 other fields	High correlation
`mission_difficulty` is highly correlated with `mission_played`	High correlation
`mission_stars_collected` is highly correlated with `mission_played`	High correlation
`day_auto_increment` is highly correlated with `days_played_in_month`	High correlation
`lifetime_played_runs` is highly correlated with `mission_played`	High correlation
`max_run_distance` is highly correlated with `mission_played`	High correlation
`days_played_in_month` is highly correlated with `day_auto_increment`	High correlation
`mission_played` is highly correlated with `mission_difficulty` and 3 other fields	High correlation
`mission_stars_collected` is highly correlated with `lifetime_played_runs` and 1 other fields	High correlation
`day_auto_increment` is highly correlated with `days_played_in_month`	High correlation
`lifetime_played_runs` is highly correlated with `mission_stars_collected` and 1 other fields	High correlation
`days_played_in_month` is highly correlated with `day_auto_increment`	High correlation
`mission_played` is highly correlated with `mission_stars_collected` and 1 other fields	High correlation
`mission_id` is highly correlated with `mission_played`	High correlation
`mission_difficulty` is highly correlated with `mission_played`	High correlation
`day_auto_increment` is highly correlated with `days_played_in_month`	High correlation
`max_run_distance` is highly correlated with `total_ads_watched`	High correlation
`total_ads_watched` is highly correlated with `max_run_distance`	High correlation
`days_played_in_month` is highly correlated with `day_auto_increment`	High correlation
`mission_played` is highly correlated with `mission_id` and 1 other fields	High correlation
`mission_stars_collected` is highly skewed (γ1 = 158.6920513)	Skewed
`total_purchases_real` is highly skewed (γ1 = 67.63920479)	Skewed
`virtual_currency_balance` is highly skewed (γ1 = 78.74891214)	Skewed
`event_timestamp` is uniformly distributed	Uniform
`target_max_day_played` has 225886 (8.4%) zeros	Zeros
`day_auto_increment` has 1683097 (62.8%) zeros	Zeros
`total_purchases_virtual` has 1318046 (49.2%) zeros	Zeros
`total_ads_watched` has 1395498 (52.1%) zeros	Zeros
`total_purchases_real` has 2665246 (99.4%) zeros	Zeros
`days_played_in_month` has 1817797 (67.8%) zeros	Zeros

Reproduction

Analysis started	2022-05-25 15:23:28.406530
Analysis finished	2022-05-25 15:29:47.621821
Duration	6 minutes and 19.22 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

Distinct	268662
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	151370.7859

Minimum	0
Maximum	290201
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	13639
Q1	86348.75
median	154225
Q3	222213
95-th percentile	276615
Maximum	290201
Range	290201
Interquartile range (IQR)	135864.25

Descriptive statistics

Standard deviation	82835.14281
Coefficient of variation (CV)	0.5472333538
Kurtosis	-1.096503108
Mean	151370.7859
Median Absolute Deviation (MAD)	67932
Skewness	-0.1304178715
Sum	4.056797609 × 10¹¹
Variance	6861660884
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
78868	10	< 0.1%
274629	10	< 0.1%
250064	10	< 0.1%
87313	10	< 0.1%
155234	10	< 0.1%
248571	10	< 0.1%
145527	10	< 0.1%
219475	10	< 0.1%
250635	10	< 0.1%
183756	10	< 0.1%
Other values (268652)	2679940	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10	< 0.1%
1	10	< 0.1%
2	10	< 0.1%
3	10	< 0.1%
4	10	< 0.1%
5	10	< 0.1%
6	10	< 0.1%
7	10	< 0.1%
8	10	< 0.1%
9	10	< 0.1%

Value	Count	Frequency (%)
290201	10	< 0.1%
290200	10	< 0.1%
290199	10	< 0.1%
290198	10	< 0.1%
290197	10	< 0.1%
290196	10	< 0.1%
290195	10	< 0.1%
290194	10	< 0.1%
290193	10	< 0.1%
290192	10	< 0.1%

user_pseudo_id
Real number (ℝ_≥0)

Distinct	268662
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49983770.56

Minimum	794
Maximum	99999617
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	794
5-th percentile	5015829
Q1	24965731
median	50053499
Q3	74913508
95-th percentile	94929788
Maximum	99999617
Range	99998823
Interquartile range (IQR)	49947777

Descriptive statistics

Standard deviation	28862679.47
Coefficient of variation (CV)	0.5774410204
Kurtosis	-1.201938662
Mean	49983770.56
Median Absolute Deviation (MAD)	24976003
Skewness	-0.002183217932
Sum	1.339585044 × 10¹⁴
Variance	8.330542664 × 10¹⁴
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
794	10	< 0.1%
66566738	10	< 0.1%
66566798	10	< 0.1%
66567847	10	< 0.1%
66567945	10	< 0.1%
66568676	10	< 0.1%
66568770	10	< 0.1%
66568994	10	< 0.1%
66569413	10	< 0.1%
66569946	10	< 0.1%
Other values (268652)	2679940	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
794	10	< 0.1%
943	10	< 0.1%
1030	10	< 0.1%
2511	10	< 0.1%
2723	10	< 0.1%
2991	10	< 0.1%
3194	10	< 0.1%
3842	10	< 0.1%
5480	10	< 0.1%
6213	10	< 0.1%

Value	Count	Frequency (%)
99999617	10	< 0.1%
99999432	10	< 0.1%
99999334	10	< 0.1%
99998701	10	< 0.1%
99998367	10	< 0.1%
99998240	10	< 0.1%
99997868	10	< 0.1%
99997620	10	< 0.1%
99997310	10	< 0.1%
99996452	10	< 0.1%

target_max_day_played
Real number (ℝ_≥0)

ZEROS

Distinct	111
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.445219474

Minimum	0
Maximum	184
Zeros	225886
Zeros (%)	8.4%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	4
Q3	8
95-th percentile	21
Maximum	184
Range	184
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	7.95990996
Coefficient of variation (CV)	1.235009916
Kurtosis	21.18527688
Mean	6.445219474
Median Absolute Deviation (MAD)	3
Skewness	3.559841456
Sum	17273446
Variance	63.36016657
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	347321	13.0%
2	339491	12.7%
3	293519	11.0%
4	241931	9.0%
0	225886	8.4%
5	199386	7.4%
6	164302	6.1%
7	132438	4.9%
8	109220	4.1%
9	90444	3.4%
Other values (101)	536102	20.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	225886	8.4%
1	347321	13.0%
2	339491	12.7%
3	293519	11.0%
4	241931	9.0%
5	199386	7.4%
6	164302	6.1%
7	132438	4.9%
8	109220	4.1%
9	90444	3.4%

Value	Count	Frequency (%)
184	10	< 0.1%
159	10	< 0.1%
151	10	< 0.1%
141	10	< 0.1%
128	10	< 0.1%
107	10	< 0.1%
106	20	< 0.1%
103	20	< 0.1%
102	20	< 0.1%
101	20	< 0.1%

mission_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	223
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59.2186986

Minimum	1
Maximum	372
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	11
median	66
Q3	113
95-th percentile	115
Maximum	372
Range	371
Interquartile range (IQR)	102

Descriptive statistics

Standard deviation	49.15026032
Coefficient of variation (CV)	0.829978731
Kurtosis	-1.797156115
Mean	59.2186986
Median Absolute Deviation (MAD)	48
Skewness	0.04218996138
Sum	158708481
Variance	2415.748089
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
115	278002	10.4%
3	277925	10.4%
86	269273	10.0%
114	259776	9.7%
19	259288	9.7%
11	258687	9.7%
113	255342	9.5%
109	254863	9.5%
6	248149	9.3%
12	187138	7.0%
Other values (213)	131597	4.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	< 0.1%
3	277925	10.4%
5	90	< 0.1%
6	248149	9.3%
7	602	< 0.1%
8	20	< 0.1%
9	100	< 0.1%
10	77412	2.9%
11	258687	9.7%
12	187138	7.0%

Value	Count	Frequency (%)
372	2	< 0.1%
371	1	< 0.1%
370	4	< 0.1%
369	6	< 0.1%
367	1	< 0.1%
366	3	< 0.1%
364	5	< 0.1%
363	8	< 0.1%
361	1	< 0.1%
360	7	< 0.1%

mission_difficulty
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.4 MiB

1.0	1933528
2.0	746492
3.0	20

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	1933528	72.1%
2.0	746492	27.9%
3.0	20	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	1933528	72.1%
2.0	746492	27.9%
3.0	20	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

mission_stars_collected
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	78
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.50493724

Minimum	0
Maximum	1772
Zeros	5959
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	4
median	7
Q3	11
95-th percentile	14
Maximum	1772
Range	1772
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.042256999
Coefficient of variation (CV)	0.6718586495
Kurtosis	55099.91193
Mean	7.50493724
Median Absolute Deviation (MAD)	3
Skewness	158.6920513
Sum	20113532
Variance	25.42435564
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	483211	18.0%
6	276592	10.3%
8	259368	9.7%
4	232340	8.7%
7	214456	8.0%
5	206933	7.7%
11	192766	7.2%
14	176941	6.6%
9	175642	6.6%
12	130291	4.9%
Other values (68)	331500	12.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5959	0.2%
1	16357	0.6%
2	6960	0.3%
3	483211	18.0%
4	232340	8.7%
5	206933	7.7%
6	276592	10.3%
7	214456	8.0%
8	259368	9.7%
9	175642	6.6%

Value	Count	Frequency (%)
1772	1	< 0.1%
1769	2	< 0.1%
1768	1	< 0.1%
1766	1	< 0.1%
1765	1	< 0.1%
1761	2	< 0.1%
1760	1	< 0.1%
1759	1	< 0.1%
280	1	< 0.1%
277	1	< 0.1%

day_auto_increment
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6727026462

Minimum	0
Maximum	58
Zeros	1683097
Zeros (%)	62.8%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	58
Range	58
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.283770145
Coefficient of variation (CV)	1.908376832
Kurtosis	44.35873336
Mean	0.6727026462
Median Absolute Deviation (MAD)	0
Skewness	4.363842316
Sum	1802870
Variance	1.648065786
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1683097	62.8%
1	611625	22.8%
2	203464	7.6%
3	86629	3.2%
4	41820	1.6%
5	22351	0.8%
6	11932	0.4%
7	6907	0.3%
8	4131	0.2%
9	2660	0.1%
Other values (40)	5424	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1683097	62.8%
1	611625	22.8%
2	203464	7.6%
3	86629	3.2%
4	41820	1.6%
5	22351	0.8%
6	11932	0.4%
7	6907	0.3%
8	4131	0.2%
9	2660	0.1%

Value	Count	Frequency (%)
58	1	< 0.1%
52	1	< 0.1%
51	1	< 0.1%
50	6	< 0.1%
46	1	< 0.1%
45	1	< 0.1%
44	1	< 0.1%
42	1	< 0.1%
41	2	< 0.1%
40	2	< 0.1%

lifetime_played_runs
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	285
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.16777772

Minimum	0
Maximum	632
Zeros	5769
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	4
Q3	8
95-th percentile	19
Maximum	632
Range	632
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	7.930375263
Coefficient of variation (CV)	1.28577514
Kurtosis	184.8159278
Mean	6.16777772
Median Absolute Deviation (MAD)	2
Skewness	7.62512371
Sum	16529891
Variance	62.8908518
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	542669	20.2%
1	417848	15.6%
3	328215	12.2%
4	237218	8.9%
5	190534	7.1%
6	158236	5.9%
7	128681	4.8%
8	105395	3.9%
9	84058	3.1%
10	68743	2.6%
Other values (275)	418443	15.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5769	0.2%
1	417848	15.6%
2	542669	20.2%
3	328215	12.2%
4	237218	8.9%
5	190534	7.1%
6	158236	5.9%
7	128681	4.8%
8	105395	3.9%
9	84058	3.1%

Value	Count	Frequency (%)
632	1	< 0.1%
454	10	< 0.1%
408	1	< 0.1%
406	1	< 0.1%
403	1	< 0.1%
402	3	< 0.1%
389	1	< 0.1%
387	2	< 0.1%
386	2	< 0.1%
385	3	< 0.1%

max_run_distance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	9672
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2385.666054

Minimum	0
Maximum	28463
Zeros	5795
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1140
Q1	1501
median	2134
Q3	2905
95-th percentile	4628
Maximum	28463
Range	28463
Interquartile range (IQR)	1404

Descriptive statistics

Standard deviation	1189.046409
Coefficient of variation (CV)	0.4984127629
Kurtosis	7.483256069
Mean	2385.666054
Median Absolute Deviation (MAD)	677
Skewness	1.876945208
Sum	6393680451
Variance	1413831.364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5795	0.2%
1224	1710	0.1%
1145	1707	0.1%
1160	1699	0.1%
1167	1696	0.1%
1201	1694	0.1%
1311	1691	0.1%
1234	1682	0.1%
1181	1679	0.1%
1312	1673	0.1%
Other values (9662)	2659014	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5795	0.2%
103	1	< 0.1%
104	3	< 0.1%
108	2	< 0.1%
113	2	< 0.1%
117	2	< 0.1%
118	3	< 0.1%
119	1	< 0.1%
122	2	< 0.1%
123	3	< 0.1%

Value	Count	Frequency (%)
28463	1	< 0.1%
24648	10	< 0.1%
22371	4	< 0.1%
21744	1	< 0.1%
20807	4	< 0.1%
20153	2	< 0.1%
20053	3	< 0.1%
19962	1	< 0.1%
18915	2	< 0.1%
18876	3	< 0.1%

total_purchases_virtual
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	5242
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33653.92234

Minimum	0
Maximum	8099500
Zeros	1318046
Zeros (%)	49.2%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	500
Q3	4000
95-th percentile	11000
Maximum	8099500
Range	8099500
Interquartile range (IQR)	4000

Descriptive statistics

Standard deviation	368409.9334
Coefficient of variation (CV)	10.94701324
Kurtosis	165.7536268
Mean	33653.92234
Median Absolute Deviation (MAD)	500
Skewness	12.64392757
Sum	9.019385802 × 10¹⁰
Variance	1.35725879 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1318046	49.2%
1500	314269	11.7%
4000	127917	4.8%
5500	87067	3.2%
3000	80291	3.0%
500	65517	2.4%
4500	64209	2.4%
6000	58088	2.2%
1000	48538	1.8%
2000	45424	1.7%
Other values (5232)	470674	17.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1318046	49.2%
500	65517	2.4%
1000	48538	1.8%
1500	314269	11.7%
2000	45424	1.7%
2500	37633	1.4%
3000	80291	3.0%
3500	23910	0.9%
4000	127917	4.8%
4500	64209	2.4%

Value	Count	Frequency (%)
8099500	1	< 0.1%
8098500	1	< 0.1%
8081000	1	< 0.1%
8012000	1	< 0.1%
8009000	1	< 0.1%
7928000	1	< 0.1%
7927000	1	< 0.1%
7922500	1	< 0.1%
7921500	1	< 0.1%
7920500	1	< 0.1%

total_ads_watched
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	170
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.431097297

Minimum	0
Maximum	239
Zeros	1395498
Zeros (%)	52.1%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	11
Maximum	239
Range	239
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	4.999152451
Coefficient of variation (CV)	2.056335819
Kurtosis	82.71175618
Mean	2.431097297
Median Absolute Deviation (MAD)	0
Skewness	5.938305411
Sum	6515438
Variance	24.99152523
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1395498	52.1%
1	319677	11.9%
2	217009	8.1%
3	161255	6.0%
4	122364	4.6%
5	93120	3.5%
6	70813	2.6%
7	54818	2.0%
8	42215	1.6%
9	33258	1.2%
Other values (160)	170013	6.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1395498	52.1%
1	319677	11.9%
2	217009	8.1%
3	161255	6.0%
4	122364	4.6%
5	93120	3.5%
6	70813	2.6%
7	54818	2.0%
8	42215	1.6%
9	33258	1.2%

Value	Count	Frequency (%)
239	1	< 0.1%
235	1	< 0.1%
230	1	< 0.1%
225	1	< 0.1%
220	1	< 0.1%
217	1	< 0.1%
205	1	< 0.1%
202	1	< 0.1%
201	3	< 0.1%
198	1	< 0.1%

total_purchases_real
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	605
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.02279883509

Minimum	0
Maximum	133.93
Zeros	2665246
Zeros (%)	99.4%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	133.93
Range	133.93
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6211283974
Coefficient of variation (CV)	27.24386553
Kurtosis	6996.434685
Mean	0.02279883509
Median Absolute Deviation (MAD)	0
Skewness	67.63920479
Sum	61101.79
Variance	0.3858004861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2665246	99.4%
1.99	2135	0.1%
0.48	1147	< 0.1%
0.49	813	< 0.1%
4.98	661	< 0.1%
0.99	598	< 0.1%
0.37	440	< 0.1%
2.99	420	< 0.1%
3.99	356	< 0.1%
0.11	261	< 0.1%
Other values (595)	7963	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2665246	99.4%
0.11	261	< 0.1%
0.13	5	< 0.1%
0.14	25	< 0.1%
0.22	71	< 0.1%
0.27	2	< 0.1%
0.3	1	< 0.1%
0.31	48	< 0.1%
0.32	29	< 0.1%
0.33	155	< 0.1%

Value	Count	Frequency (%)
133.93	1	< 0.1%
96.69	4	< 0.1%
94.7	1	< 0.1%
92.53	3	< 0.1%
79.91	6	< 0.1%
78.76	4	< 0.1%
73.94	3	< 0.1%
73.93	10	< 0.1%
67.83	10	< 0.1%
64.97	6	< 0.1%

geo_country
Categorical

HIGH CARDINALITY

Distinct	220
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.4 MiB

United States	449106
Mexico	341118
Brazil	131641
France	112166
Russia	107711
Other values (215)	1538298

Length

Max length	24
Median length	7
Mean length	8.140946404
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	India
2nd row	India
3rd row	India
4th row	India
5th row	India

Common Values

Value	Count	Frequency (%)
United States	449106	16.8%
Mexico	341118	12.7%
Brazil	131641	4.9%
France	112166	4.2%
Russia	107711	4.0%
India	96080	3.6%
Germany	91052	3.4%
Turkey	82896	3.1%
United Kingdom	82838	3.1%
Colombia	68028	2.5%
Other values (210)	1117404	41.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
united	538218	16.2%
states	449106	13.5%
mexico	341118	10.3%
brazil	131641	4.0%
france	112166	3.4%
russia	107711	3.2%
india	96080	2.9%
germany	91052	2.7%
turkey	82896	2.5%
kingdom	82838	2.5%
Other values (249)	1281760	38.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

days_played_in_month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4930090596

Minimum	0
Maximum	25
Zeros	1817797
Zeros (%)	67.8%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	25
Range	25
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9290332314
Coefficient of variation (CV)	1.884414116
Kurtosis	18.69182895
Mean	0.4930090596
Median Absolute Deviation (MAD)	0
Skewness	3.227741826
Sum	1321284
Variance	0.863102745
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	1817797	67.8%
1	592554	22.1%
2	165924	6.2%
3	59195	2.2%
4	24085	0.9%
5	10830	0.4%
6	4801	0.2%
7	2282	0.1%
8	1160	< 0.1%
9	617	< 0.1%
Other values (16)	795	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1817797	67.8%
1	592554	22.1%
2	165924	6.2%
3	59195	2.2%
4	24085	0.9%
5	10830	0.4%
6	4801	0.2%
7	2282	0.1%
8	1160	< 0.1%
9	617	< 0.1%

Value	Count	Frequency (%)
25	1	< 0.1%
24	3	< 0.1%
23	3	< 0.1%
22	2	< 0.1%
21	1	< 0.1%
20	5	< 0.1%
19	3	< 0.1%
18	7	< 0.1%
17	13	< 0.1%
16	11	< 0.1%

virtual_currency_balance
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	46605
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	328729.3675

Minimum	0
Maximum	2146000000
Zeros	200
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	0
5-th percentile	605
Q1	4017
median	5648
Q3	6987
95-th percentile	11442
Maximum	2146000000
Range	2146000000
Interquartile range (IQR)	2970

Descriptive statistics

Standard deviation	16969510.17
Coefficient of variation (CV)	51.62152166
Kurtosis	7010.745718
Mean	328729.3675
Median Absolute Deviation (MAD)	1523
Skewness	78.74891214
Sum	8.810078542 × 10¹¹
Variance	2.879642753 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5579	1858	0.1%
5570	1841	0.1%
5554	1827	0.1%
5545	1801	0.1%
5571	1789	0.1%
5574	1788	0.1%
5559	1767	0.1%
5562	1766	0.1%
5566	1765	0.1%
5548	1755	0.1%
Other values (46595)	2662083	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	200	< 0.1%
1	166	< 0.1%
2	183	< 0.1%
3	173	< 0.1%
4	175	< 0.1%
5	181	< 0.1%
6	156	< 0.1%
7	178	< 0.1%
8	162	< 0.1%
9	154	< 0.1%

Value	Count	Frequency (%)
2146000000	9	< 0.1%
2000000000	4	< 0.1%
1999990000	1	< 0.1%
1997650000	2	< 0.1%
1996150000	3	< 0.1%
1996140000	5	< 0.1%
1995620000	10	< 0.1%
1995250000	10	< 0.1%
1994110000	5	< 0.1%
1994100000	8	< 0.1%

event_timestamp
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	1722186
Distinct (%)	64.3%
Missing	0
Missing (%)	0.0%
Memory size	20.4 MiB

03-02-2022 15:34:43	10
22-02-2022 20:34:24	10
04-02-2022 23:45:10	9
12-02-2022 18:03:09	9
27-02-2022 16:13:14	9
Other values (1722181)	2679993

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1062528 ?
Unique (%)	39.6%

Sample

1st row	19-02-2022 18:47:18
2nd row	19-02-2022 18:47:52
3rd row	19-02-2022 18:47:57
4th row	19-02-2022 18:51:30
5th row	19-02-2022 18:53:40

Common Values

Value	Count	Frequency (%)
03-02-2022 15:34:43	10	< 0.1%
22-02-2022 20:34:24	10	< 0.1%
04-02-2022 23:45:10	9	< 0.1%
12-02-2022 18:03:09	9	< 0.1%
27-02-2022 16:13:14	9	< 0.1%
11-02-2022 16:00:17	9	< 0.1%
10-02-2022 18:03:11	9	< 0.1%
22-02-2022 17:11:11	9	< 0.1%
27-02-2022 20:39:33	9	< 0.1%
10-02-2022 02:28:20	9	< 0.1%
Other values (1722176)	2679948	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
27-02-2022	102729	1.9%
26-02-2022	101032	1.9%
20-02-2022	100948	1.9%
25-02-2022	97505	1.8%
19-02-2022	96787	1.8%
22-02-2022	96127	1.8%
21-02-2022	94737	1.8%
13-02-2022	94730	1.8%
06-02-2022	94083	1.8%
12-02-2022	93916	1.8%
Other values (86499)	4387486	81.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

mission_played
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.496324309

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	10
Maximum	10
Range	9
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.87192445
Coefficient of variation (CV)	0.522517284
Kurtosis	-1.224021514
Mean	5.496324309
Median Absolute Deviation (MAD)	2
Skewness	0.001494280985
Sum	14730369
Variance	8.247950045
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	268437	10.0%
2	268384	10.0%
3	268319	10.0%
4	268208	10.0%
5	268123	10.0%
6	268033	10.0%
7	267886	10.0%
8	267762	10.0%
9	267616	10.0%
10	267272	10.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	268437	10.0%
2	268384	10.0%
3	268319	10.0%
4	268208	10.0%
5	268123	10.0%
6	268033	10.0%
7	267886	10.0%
8	267762	10.0%
9	267616	10.0%
10	267272	10.0%

Value	Count	Frequency (%)
10	267272	10.0%
9	267616	10.0%
8	267762	10.0%
7	267886	10.0%
6	268033	10.0%
5	268123	10.0%
4	268208	10.0%
3	268319	10.0%
2	268384	10.0%
1	268437	10.0%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	user_pseudo_id	mission_id	mission_difficulty	mission_stars_collected	lifetime_played_runs	max_run_distance	total_purchases_virtual	total_ads_watched	geo_country	virtual_currency_balance	event_timestamp	mission_played
0	78868	794	115	1.0	3.0	1.0	1183.0	0.0	0.0	India	5715.0	19-02-2022 18:47:18	1
1	78868	794	113	1.0	3.0	1.0	1183.0	0.0	0.0	India	5715.0	19-02-2022 18:47:52	2
2	78868	794	109	1.0	3.0	1.0	1183.0	0.0	0.0	India	5715.0	19-02-2022 18:47:57	3
3	78868	794	11	1.0	6.0	3.0	1695.0	0.0	2.0	India	6842.0	19-02-2022 18:51:30	4
4	78868	794	114	1.0	7.0	4.0	1695.0	0.0	3.0	India	7342.0	19-02-2022 18:53:40	5
5	78868	794	3	1.0	7.0	4.0	1695.0	0.0	3.0	India	7342.0	19-02-2022 18:54:10	6
6	78868	794	19	2.0	9.0	5.0	2104.0	0.0	5.0	India	8284.0	19-02-2022 18:59:12	7
7	78868	794	86	2.0	11.0	6.0	2104.0	0.0	6.0	India	8941.0	19-02-2022 19:00:13	8
8	78868	794	12	2.0	11.0	6.0	2104.0	0.0	6.0	India	8941.0	19-02-2022 19:00:20	9
9	78868	794	6	1.0	15.0	8.0	2104.0	6000.0	8.0	India	3849.0	20-02-2022 04:33:14	10

Last rows

	df_index	user_pseudo_id	target_max_day_played	mission_id	mission_difficulty	mission_stars_collected	day_auto_increment	lifetime_played_runs	max_run_distance	total_purchases_virtual	geo_country	days_played_in_month	virtual_currency_balance	event_timestamp	mission_played
2680030	129581	99999617	2	113	1.0	3.0	1.0	1.0	1498.0	0.0	Mexico	1.0	5563.0	12-02-2022 14:58:38	1
2680031	129581	99999617	2	109	1.0	3.0	1.0	1.0	1498.0	0.0	Mexico	1.0	5563.0	12-02-2022 14:58:55	2
2680032	129581	99999617	2	3	1.0	5.0	1.0	2.0	1498.0	0.0	Mexico	1.0	5632.0	12-02-2022 15:00:37	3
2680033	129581	99999617	2	11	1.0	5.0	1.0	2.0	1498.0	0.0	Mexico	1.0	5632.0	12-02-2022 15:01:11	4
2680034	129581	99999617	2	114	1.0	7.0	1.0	3.0	1888.0	1500.0	Mexico	1.0	5368.0	12-02-2022 15:02:36	5
2680035	129581	99999617	2	115	1.0	7.0	1.0	3.0	1888.0	1500.0	Mexico	1.0	5368.0	12-02-2022 15:02:46	6
2680036	129581	99999617	2	6	1.0	7.0	1.0	3.0	1888.0	1500.0	Mexico	1.0	5368.0	12-02-2022 15:03:07	7
2680037	129581	99999617	2	19	2.0	10.0	1.0	4.0	1888.0	4000.0	Mexico	1.0	3616.0	12-02-2022 15:04:28	8
2680038	129581	99999617	2	12	2.0	12.0	1.0	5.0	1888.0	4000.0	Mexico	1.0	3616.0	12-02-2022 15:05:36	9
2680039	129581	99999617	2	86	2.0	14.0	1.0	6.0	1888.0	4000.0	Mexico	1.0	4463.0	12-02-2022 15:09:46	10

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows